<html>
<!-- For multiline headers use | as divider in fields captions  -->
<style>
 {{{defaultstyle}}}
 body {margin: 20px 20px; }
 table {box-shadow: 5 5 10 #777;}
 td, th {border: solid #eee 1px; font-size: 12px; padding: 2 2; }
 th {background: #888; color: white; padding: 5px 5px;
    resize: horizontal;
    draggable: true;
   }
 .table-group-box {background: #888; border: solid #555 1px; padding: 3 3; margin: 5 0; color: white }
 .group {background: #686; font-weight: bold; font-size: 16px; color: white}
 h2 { box-reflect: below -5px linear-gradient(top, rgba(255, 255, 255, 0.3), rgba(255, 255, 255, 1) 70%, white);
</style>

<report-params>
 <param name="state" caption="State" type="list" template=" and state=:state_value" sql="select distinct state, state from customer"/>
 <param name="company" caption="Company" type="string" template=" and company starting with :company_value"/>
</report-params>


<h2>Customer list</h2>

<br>
<DATAPACKET>
 <METADATA autosort="true">
  <FIELDS>
   <FIELD name="CUSTNO" caption="No"/>
   <FIELD name="COMPANY" caption="Company"/>
   <FIELD name="STATE" caption="Address|State" arowspan="*"/>
   <FIELD name="CITY" caption="Address|City" arowspan="*"/>
   <FIELD name="ADDR1" caption="Address|Street" />
   <FIELD name="PHONE" caption="Phone"/>
   <FIELD name="CONTACT" caption="Contact"/>
  </FIELDS>
  <SQL>
   select * from customer
   where (1=1)  {{state}} {{company}}
   order by state desc
  </SQL>
 </METADATA>
</DATAPACKET>

</html>
